Skip to main content

📝 Create Record

The Create Record action allows you to insert a new record into a specified database table by defining values for its columns.


Configuration

  • Name: Enter a descriptive name for the create record action.
  • Select Source: Choose the data source or connection from which to create the record.
  • Select Schema: Select the database schema where the target table resides.
  • Select Table: Choose the table where the new record will be inserted.
  • Select Column: Define one or more columns and their values to be set for the new record. For each column:
    • Select the column name.
    • Enter the value or use an expression (fx) to dynamically assign it.
    • Use the plus (+) button to add more columns or the trash icon to remove.

Features

  • Supports inserting records with multiple column values.
  • Allows dynamic value assignment using expressions.
  • Integrates with various data sources and schemas.
  • Provides flexible configuration for diverse database structures.

Use Cases

  • Add new entries to user, order, or product tables.
  • Populate audit logs or transaction records.
  • Create linked records during complex workflows.
  • Insert data gathered from user inputs or external sources.

Notes

  • Ensure the selected source, schema, and table exist and are accessible.
  • Validate column data types and constraints to prevent insertion errors.
  • Use expressions to set values based on workflow variables or calculations.

Tip: Combine Create Record with other data actions like Filter or Select to automate data population workflows.